drop database if exists pigxx_job;
create database pigxx_job default character set utf8mb4 collate utf8mb4_general_ci;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `blob_data` blob,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `calendar_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `calendar` blob NOT NULL,
  PRIMARY KEY (`sched_name`,`calendar_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `cron_expression` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `time_zone_id` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` VALUES ('clusteredScheduler', '每秒刷新标记价', 'system', '* * * * * ? *', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `entry_id` varchar(95) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `instance_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `fired_time` bigint NOT NULL,
  `sched_time` bigint NOT NULL,
  `priority` int NOT NULL,
  `state` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `job_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `requests_recovery` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`entry_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `job_class_name` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `is_durable` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `is_update_data` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `requests_recovery` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job_data` blob,
  PRIMARY KEY (`sched_name`,`job_name`,`job_group`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` VALUES ('clusteredScheduler', '每秒刷新标记价', 'system', NULL, 'com.pig4cloud.pigx.daemon.quartz.config.PigxQuartzFactory', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000B7363686564756C654A6F627372002E636F6D2E70696734636C6F75642E706967782E6461656D6F6E2E71756172747A2E656E746974792E5379734A6F6200000000000000010200174C0009636C6173734E616D657400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000E63726F6E45787072657373696F6E71007E00094C000B657865637574655061746871007E00094C00106A6F624578656375746553746174757371007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C00086A6F624F7264657271007E00094C00096A6F6253746174757371007E00094C000D6A6F6254656E616E745479706571007E00094C00076A6F625479706571007E00094C000A6D6574686F644E616D6571007E00094C00116D6574686F64506172616D7356616C756571007E00094C000D6D697366697265506F6C69637971007E00094C00086E65787454696D6571007E000A4C000C70726576696F757354696D6571007E000A4C000672656D61726B71007E00094C0009737461727454696D6571007E000A4C000874656E616E74496471007E000B4C0008757064617465427971007E00094C000A75706461746554696D6571007E000A78720035636F6D2E62616F6D69646F752E6D796261746973706C75732E657874656E73696F6E2E6163746976657265636F72642E4D6F64656C00000000000000010200007870740012666C7573684D61726B50726963655461736B74000367646B7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E6080B130DF57874000D2A202A202A202A202A203F202A707400013074000673797374656D7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870159E03ABCE194001740015E6AF8FE7A792E588B7E696B0E6A087E8AEB0E4BBB77400013174000131740001317400013274000372756E70740001317070740042E6AF8FE7A792E6A0B9E68DAEE69C80E8BF91E79A84E8A18CE68385E68B89E58F96E8AEB0E5BD95E588B7E696B0E7BC93E5AD98E4B8ADE79A84E6A087E8AEB0E4BBB7707371007E001500000000000000017400007371007E0010770A05000007E6080B0B0DF5787800);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `lock_name` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`sched_name`,`lock_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('clusteredScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('clusteredScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`sched_name`,`trigger_group`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `instance_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `last_checkin_time` bigint NOT NULL,
  `checkin_interval` bigint NOT NULL,
  PRIMARY KEY (`sched_name`,`instance_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('clusteredScheduler', '192.168.0.1331660225218465', 1660225302909, 10000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `repeat_count` bigint NOT NULL,
  `repeat_interval` bigint NOT NULL,
  `times_triggered` bigint NOT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_IBFK_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_simple_triggers` VALUES ('clusteredScheduler', 'MT_1ro1x4qpk7ja0', 'DEFAULT', 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `str_prop_1` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `str_prop_2` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `str_prop_3` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `int_prop_1` int DEFAULT NULL,
  `int_prop_2` int DEFAULT NULL,
  `long_prop_1` bigint DEFAULT NULL,
  `long_prop_2` bigint DEFAULT NULL,
  `dec_prop_1` decimal(13,4) DEFAULT NULL,
  `dec_prop_2` decimal(13,4) DEFAULT NULL,
  `bool_prop_1` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `bool_prop_2` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_IBFK_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `sched_name` varchar(120) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job_group` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `description` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `next_fire_time` bigint DEFAULT NULL,
  `prev_fire_time` bigint DEFAULT NULL,
  `priority` int DEFAULT NULL,
  `trigger_state` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `trigger_type` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `start_time` bigint NOT NULL,
  `end_time` bigint DEFAULT NULL,
  `calendar_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `misfire_instr` smallint DEFAULT NULL,
  `job_data` blob,
  PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  KEY `sched_name` (`sched_name`,`job_name`,`job_group`) USING BTREE,
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` VALUES ('clusteredScheduler', 'MT_1ro1x4qpk7ja0', 'DEFAULT', '每秒刷新标记价', 'system', NULL, 1660224763903, -1, 5, 'PAUSED', 'SIMPLE', 1660224763903, 0, NULL, 0, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000B7363686564756C654A6F627372002E636F6D2E70696734636C6F75642E706967782E6461656D6F6E2E71756172747A2E656E746974792E5379734A6F6200000000000000010200174C0009636C6173734E616D657400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000E63726F6E45787072657373696F6E71007E00094C000B657865637574655061746871007E00094C00106A6F624578656375746553746174757371007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C00086A6F624F7264657271007E00094C00096A6F6253746174757371007E00094C000D6A6F6254656E616E745479706571007E00094C00076A6F625479706571007E00094C000A6D6574686F644E616D6571007E00094C00116D6574686F64506172616D7356616C756571007E00094C000D6D697366697265506F6C69637971007E00094C00086E65787454696D6571007E000A4C000C70726576696F757354696D6571007E000A4C000672656D61726B71007E00094C0009737461727454696D6571007E000A4C000874656E616E74496471007E000B4C0008757064617465427971007E00094C000A75706461746554696D6571007E000A78720035636F6D2E62616F6D69646F752E6D796261746973706C75732E657874656E73696F6E2E6163746976657265636F72642E4D6F64656C00000000000000010200007870740012666C7573684D61726B50726963655461736B74000367646B7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E6080B130DF57874000D2A202A202A202A202A203F202A707400013174000673797374656D7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870159E03ABCE194001740015E6AF8FE7A792E588B7E696B0E6A087E8AEB0E4BBB77400013174000133740001317400013274000372756E70740001317371007E0010770A05000007E6080B130ED9787371007E0010770A05000007E6080B130EDA78740042E6AF8FE7A792E6A0B9E68DAEE69C80E8BF91E79A84E8A18CE68385E68B89E58F96E8AEB0E5BD95E588B7E696B0E7BC93E5AD98E4B8ADE79A84E6A087E8AEB0E4BBB77371007E0010770A05000007E6080B130DED787371007E00150000000000000001707371007E0010770A05000007E6080B1520DC787800);
INSERT INTO `qrtz_triggers` VALUES ('clusteredScheduler', '每秒刷新标记价', 'system', '每秒刷新标记价', 'system', NULL, 1660216478000, 1660216477000, 5, 'PAUSED', 'CRON', 1660216398000, 0, NULL, -1, 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000B7363686564756C654A6F627372002E636F6D2E70696734636C6F75642E706967782E6461656D6F6E2E71756172747A2E656E746974792E5379734A6F6200000000000000010200174C0009636C6173734E616D657400124C6A6176612F6C616E672F537472696E673B4C0008637265617465427971007E00094C000A63726561746554696D657400194C6A6176612F74696D652F4C6F63616C4461746554696D653B4C000E63726F6E45787072657373696F6E71007E00094C000B657865637574655061746871007E00094C00106A6F624578656375746553746174757371007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C00086A6F624F7264657271007E00094C00096A6F6253746174757371007E00094C000D6A6F6254656E616E745479706571007E00094C00076A6F625479706571007E00094C000A6D6574686F644E616D6571007E00094C00116D6574686F64506172616D7356616C756571007E00094C000D6D697366697265506F6C69637971007E00094C00086E65787454696D6571007E000A4C000C70726576696F757354696D6571007E000A4C000672656D61726B71007E00094C0009737461727454696D6571007E000A4C000874656E616E74496471007E000B4C0008757064617465427971007E00094C000A75706461746554696D6571007E000A78720035636F6D2E62616F6D69646F752E6D796261746973706C75732E657874656E73696F6E2E6163746976657265636F72642E4D6F64656C00000000000000010200007870740012666C7573684D61726B50726963655461736B74000367646B7372000D6A6176612E74696D652E536572955D84BA1B2248B20C00007870770A05000007E6080B130DF57874000D2A202A202A202A202A203F202A707400013174000673797374656D7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870159E03ABCE194001740015E6AF8FE7A792E588B7E696B0E6A087E8AEB0E4BBB77400013174000133740001317400013274000372756E70740001317371007E0010770A05000007E6080B1311F2787371007E0010770A05000007E6080B1311F378740042E6AF8FE7A792E6A0B9E68DAEE69C80E8BF91E79A84E8A18CE68385E68B89E58F96E8AEB0E5BD95E588B7E696B0E7BC93E5AD98E4B8ADE79A84E6A087E8AEB0E4BBB77371007E0010770A05000007E6080B130DED787371007E0015000000000000000174000367646B7371007E0010770A05000007E6080B1402F2787800);
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `job_id` bigint NOT NULL COMMENT '任务id',
  `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '任务组名',
  `job_order` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '1' COMMENT '组内执行顺利，值越大执行优先级越高，最大值9，最小值1',
  `job_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '1、java类;2、spring bean名称;3、rest调用;4、jar调用;9其他',
  `execute_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'job_type=3时，rest调用地址，仅支持rest get协议,需要增加String返回值，0成功，1失败;job_type=4时，jar路径;其它值为空',
  `class_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'job_type=1时，类完整路径;job_type=2时，spring bean名称;其它值为空',
  `method_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '任务方法',
  `method_params_value` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '参数值',
  `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'cron执行表达式',
  `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '3' COMMENT '错失执行策略（1错失周期立即执行 2错失周期执行一次 3下周期执行）',
  `job_tenant_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '1' COMMENT '1、多租户任务;2、非多租户任务',
  `job_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '状态（1、未发布;2、运行中;3、暂停;4、删除;）',
  `job_execute_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '状态（0正常 1异常）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '初次执行时间',
  `previous_time` timestamp NULL DEFAULT NULL COMMENT '上次执行时间',
  `next_time` timestamp NULL DEFAULT NULL COMMENT '下次执行时间',
  `tenant_id` bigint DEFAULT '1' COMMENT '租户',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '备注信息',
  PRIMARY KEY (`job_id`,`job_name`,`job_group`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务调度表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES (1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '1', '1', '3', '1', 'gdk', '2022-08-11 19:13:10', NULL, '2022-08-11 21:40:56', '2022-08-11 19:13:18', '2022-08-11 19:14:37', '2022-08-11 19:14:38', 1, '每秒根据最近的行情拉取记录刷新缓存中的标记价');
COMMIT;

-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE `sys_job_log` (
  `job_log_id` bigint NOT NULL COMMENT '任务日志ID',
  `job_id` bigint NOT NULL COMMENT '任务id',
  `job_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '任务名称',
  `job_group` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '任务组名',
  `job_order` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '组内执行顺利，值越大执行优先级越高，最大值9，最小值1',
  `job_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1' COMMENT '1、java类;2、spring bean名称;3、rest调用;4、jar调用;9其他',
  `execute_path` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'job_type=3时，rest调用地址，仅支持post协议;job_type=4时，jar路径;其它值为空',
  `class_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'job_type=1时，类完整路径;job_type=2时，spring bean名称;其它值为空',
  `method_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '任务方法',
  `method_params_value` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '参数值',
  `cron_expression` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'cron执行表达式',
  `job_message` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '日志信息',
  `job_log_status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '0' COMMENT '执行状态（0正常 1失败）',
  `execute_time` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '执行时间',
  `exception_info` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT '' COMMENT '异常信息',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `tenant_id` bigint NOT NULL DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`job_log_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='定时任务执行日志表';

-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_job_log` VALUES (1557683761571229698, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '4', '', '2022-08-11 19:02:04', 1);
INSERT INTO `sys_job_log` VALUES (1557683762674331649, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:04', 1);
INSERT INTO `sys_job_log` VALUES (1557683767069962241, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:05', 1);
INSERT INTO `sys_job_log` VALUES (1557683771260071937, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '2', '', '2022-08-11 19:02:06', 1);
INSERT INTO `sys_job_log` VALUES (1557683775429210113, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:07', 1);
INSERT INTO `sys_job_log` VALUES (1557683779585765377, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:08', 1);
INSERT INTO `sys_job_log` VALUES (1557683783679406081, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:09', 1);
INSERT INTO `sys_job_log` VALUES (1557683784304357377, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:09', 1);
INSERT INTO `sys_job_log` VALUES (1557683787986956289, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:10', 1);
INSERT INTO `sys_job_log` VALUES (1557683792122540034, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:11', 1);
INSERT INTO `sys_job_log` VALUES (1557683796375564290, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:12', 1);
INSERT INTO `sys_job_log` VALUES (1557683800527925250, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:13', 1);
INSERT INTO `sys_job_log` VALUES (1557683804613177345, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:14', 1);
INSERT INTO `sys_job_log` VALUES (1557683808870395905, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:15', 1);
INSERT INTO `sys_job_log` VALUES (1557683813077282818, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:16', 1);
INSERT INTO `sys_job_log` VALUES (1557683817397415937, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:17', 1);
INSERT INTO `sys_job_log` VALUES (1557683821537193986, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:18', 1);
INSERT INTO `sys_job_log` VALUES (1557683825593085953, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:19', 1);
INSERT INTO `sys_job_log` VALUES (1557683829913219074, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:20', 1);
INSERT INTO `sys_job_log` VALUES (1557683834124300290, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:21', 1);
INSERT INTO `sys_job_log` VALUES (1557683838255689729, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:22', 1);
INSERT INTO `sys_job_log` VALUES (1557683842441605122, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:23', 1);
INSERT INTO `sys_job_log` VALUES (1557683846589771778, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:24', 1);
INSERT INTO `sys_job_log` VALUES (1557683850817630210, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:25', 1);
INSERT INTO `sys_job_log` VALUES (1557683855053877250, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:26', 1);
INSERT INTO `sys_job_log` VALUES (1557683859223015426, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:27', 1);
INSERT INTO `sys_job_log` VALUES (1557683863488622593, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:28', 1);
INSERT INTO `sys_job_log` VALUES (1557683867506765826, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:29', 1);
INSERT INTO `sys_job_log` VALUES (1557683871810121729, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:30', 1);
INSERT INTO `sys_job_log` VALUES (1557683876008620033, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:31', 1);
INSERT INTO `sys_job_log` VALUES (1557683880190341122, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:32', 1);
INSERT INTO `sys_job_log` VALUES (1557683884355284993, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:33', 1);
INSERT INTO `sys_job_log` VALUES (1557683888545394689, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '2', '', '2022-08-11 19:02:34', 1);
INSERT INTO `sys_job_log` VALUES (1557683892798418945, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:35', 1);
INSERT INTO `sys_job_log` VALUES (1557683896950779905, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:36', 1);
INSERT INTO `sys_job_log` VALUES (1557683901161861121, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:37', 1);
INSERT INTO `sys_job_log` VALUES (1557683905393913858, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '0', '', '2022-08-11 19:02:38', 1);
INSERT INTO `sys_job_log` VALUES (1557683925006479362, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'demo', 'demoMethod', 'xxx', '* * * * * ? *', '执行成功', '0', '1', '', '2022-08-11 19:02:43', 1);
INSERT INTO `sys_job_log` VALUES (1557684628223488001, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '8', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:30', 1);
INSERT INTO `sys_job_log` VALUES (1557684629481779201, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:31', 1);
INSERT INTO `sys_job_log` VALUES (1557684630303862786, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:31', 1);
INSERT INTO `sys_job_log` VALUES (1557684631172083714, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:31', 1);
INSERT INTO `sys_job_log` VALUES (1557684631763480578, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:31', 1);
INSERT INTO `sys_job_log` VALUES (1557684632241631233, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:31', 1);
INSERT INTO `sys_job_log` VALUES (1557684632640090114, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:31', 1);
INSERT INTO `sys_job_log` VALUES (1557684633059520513, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684633508311042, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684633952907265, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684634447835137, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684635148283905, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684635496411137, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684635794206721, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684636066836481, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684636314300418, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684636578541569, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684636826005505, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:32', 1);
INSERT INTO `sys_job_log` VALUES (1557684637107023874, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:33', 1);
INSERT INTO `sys_job_log` VALUES (1557684637685837825, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:33', 1);
INSERT INTO `sys_job_log` VALUES (1557684638486949889, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:33', 1);
INSERT INTO `sys_job_log` VALUES (1557684652441399297, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '0', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:05:36', 1);
INSERT INTO `sys_job_log` VALUES (1557684751796072450, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '3', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:06:00', 1);
INSERT INTO `sys_job_log` VALUES (1557684807106359297, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:06:13', 1);
INSERT INTO `sys_job_log` VALUES (1557684850253164545, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '1', 'No bean named \'flushMarkPriceTask\' available', '2022-08-11 19:06:23', 1);
INSERT INTO `sys_job_log` VALUES (1557685573468635138, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'excute', 'xxx', '* * * * * ? *', '执行失败', '1', '8', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:09:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686110058528769, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', 'xxx', '* * * * * ? *', '执行失败', '1', '19', '', '2022-08-11 19:11:24', 1);
INSERT INTO `sys_job_log` VALUES (1557686568525316098, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686568961523714, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686569204793345, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686569401925633, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686569628418050, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686569947185154, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686570291118081, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686570484056065, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:13', 1);
INSERT INTO `sys_job_log` VALUES (1557686570748297218, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686570945429505, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686571155144706, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '3', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686571381637122, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686571784290306, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686572065308673, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686572455378946, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686572635734018, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686572811894785, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686573038387201, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686573315211266, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686573537509378, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686573709475842, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686573902413826, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686574191820802, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686574451867649, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686574628028418, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:14', 1);
INSERT INTO `sys_job_log` VALUES (1557686574812577793, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686575114567682, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686575353643010, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686575538192386, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686575773073409, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686576054091778, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686576318332929, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686576544825346, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686576746151937, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686576918118402, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686577232691202, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '2', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686577564041218, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686577958305793, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686578193186817, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686578461622273, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686578658754562, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:15', 1);
INSERT INTO `sys_job_log` VALUES (1557686579128516610, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686579363397634, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686579631833090, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686579807993858, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686580080623617, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686580252590082, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686580420362241, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686580600717313, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686580751712257, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686581020147714, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686581234057217, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557686581577990145, 1557678925303779330, 'flushMarkPrice', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '0', '定时任务spring bean反射异常方法未找到,执行任务：flushMarkPriceTask', '2022-08-11 19:13:16', 1);
INSERT INTO `sys_job_log` VALUES (1557704446133751810, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '70', '', '2022-08-11 20:24:15', 1);
INSERT INTO `sys_job_log` VALUES (1557704446553182209, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '11', '', '2022-08-11 20:24:15', 1);
INSERT INTO `sys_job_log` VALUES (1557704447127801857, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '61', '', '2022-08-11 20:24:16', 1);
INSERT INTO `sys_job_log` VALUES (1557704448268652545, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '23', '', '2022-08-11 20:24:16', 1);
INSERT INTO `sys_job_log` VALUES (1557704448956518402, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '23', '', '2022-08-11 20:24:16', 1);
INSERT INTO `sys_job_log` VALUES (1557704449694715905, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '24', '', '2022-08-11 20:24:16', 1);
INSERT INTO `sys_job_log` VALUES (1557704450541965313, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '27', '', '2022-08-11 20:24:16', 1);
INSERT INTO `sys_job_log` VALUES (1557704451296940034, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '21', '', '2022-08-11 20:24:17', 1);
INSERT INTO `sys_job_log` VALUES (1557704451863171073, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '18', '', '2022-08-11 20:24:17', 1);
INSERT INTO `sys_job_log` VALUES (1557704452240658434, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '8', '', '2022-08-11 20:24:17', 1);
INSERT INTO `sys_job_log` VALUES (1557704453457006594, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '31', '', '2022-08-11 20:24:17', 1);
INSERT INTO `sys_job_log` VALUES (1557704454509776898, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行成功', '0', '14', '', '2022-08-11 20:24:17', 1);
INSERT INTO `sys_job_log` VALUES (1557714356875644930, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '106716', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:03:38', 1);
INSERT INTO `sys_job_log` VALUES (1557714510705938434, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '2', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:04:15', 1);
INSERT INTO `sys_job_log` VALUES (1557714693208473602, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '8', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:04:58', 1);
INSERT INTO `sys_job_log` VALUES (1557715074059665409, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '7', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:06:29', 1);
INSERT INTO `sys_job_log` VALUES (1557715114668916737, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '3', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:06:39', 1);
INSERT INTO `sys_job_log` VALUES (1557715480428994562, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '11', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:08:06', 1);
INSERT INTO `sys_job_log` VALUES (1557716427595096065, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '7', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:11:52', 1);
INSERT INTO `sys_job_log` VALUES (1557717098994118658, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '19', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:14:32', 1);
INSERT INTO `sys_job_log` VALUES (1557717545993732097, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '13', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:16:19', 1);
INSERT INTO `sys_job_log` VALUES (1557717933778108417, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '54421', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:17:51', 1);
INSERT INTO `sys_job_log` VALUES (1557720683022708737, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '8936', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:28:47', 1);
INSERT INTO `sys_job_log` VALUES (1557720950380228609, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '2', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:29:50', 1);
INSERT INTO `sys_job_log` VALUES (1557721640502681601, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '8', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:32:35', 1);
INSERT INTO `sys_job_log` VALUES (1557723711029198849, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '5', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:40:48', 1);
INSERT INTO `sys_job_log` VALUES (1557723744566853634, 1557686557548822529, '每秒刷新标记价', 'system', '1', '2', NULL, 'flushMarkPriceTask', 'run', NULL, '* * * * * ? *', '执行失败', '1', '1', '定时任务spring bean反射执行异常,执行任务：flushMarkPriceTask', '2022-08-11 21:40:56', 1);
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_group
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_group`;
CREATE TABLE `xxl_job_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器AppName',
  `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器名称',
  `address_type` tinyint NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
  `address_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '执行器地址列表，多地址逗号分隔',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_group
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_group` VALUES (1, 'roo-robot-biz', 'roo-robot', 0, NULL, '2022-08-31 20:29:54');
INSERT INTO `xxl_job_group` VALUES (2, 'roo-contract-biz', 'roo-contract', 0, 'http://192.168.0.127:10004/', '2022-08-31 20:29:54');
INSERT INTO `xxl_job_group` VALUES (3, 'roo-agent-biz', 'roo-agent', 0, 'http://192.168.0.127:10003/', '2022-08-31 20:29:54');
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_info
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_info`;
CREATE TABLE `xxl_job_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_group` int NOT NULL COMMENT '执行器主键ID',
  `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `author` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '作者',
  `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '报警邮件',
  `schedule_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
  `schedule_conf` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
  `misfire_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略',
  `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器路由策略',
  `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器任务handler',
  `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器任务参数',
  `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '阻塞处理策略',
  `executor_timeout` int NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
  `executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE类型',
  `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'GLUE源代码',
  `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'GLUE备注',
  `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新时间',
  `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
  `trigger_status` tinyint NOT NULL DEFAULT '0' COMMENT '调度状态：0-停止，1-运行',
  `trigger_last_time` bigint NOT NULL DEFAULT '0' COMMENT '上次调度时间',
  `trigger_next_time` bigint NOT NULL DEFAULT '0' COMMENT '下次调度时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_info
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_info` VALUES (2, 1, '每秒根据行情拉取记录更新当前市价', '2022-08-12 10:52:15', '2022-08-12 11:17:05', 'gdk', '1036532868@qq.com', 'CRON', '* * * * * ?', 'DO_NOTHING', 'FIRST', 'flushMarkPriceTask', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-12 10:52:15', '', 0, 0, 0);
INSERT INTO `xxl_job_info` VALUES (3, 3, '定时根据 成交订单 结算经纪人的佣金和受邀用户的返佣金', '2022-08-25 14:59:18', '2022-08-25 18:41:54', 'shf', '', 'CRON', '0 0 8 * * ?', 'DO_NOTHING', 'FIRST', 'commissionSettlementTask', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-25 14:59:18', '', 1, 1661904000000, 1661990400000);
INSERT INTO `xxl_job_info` VALUES (4, 2, '测试K线', '2022-08-29 10:39:05', '2022-08-29 10:39:05', 'shf', '', 'NONE', '', 'DO_NOTHING', 'FIRST', 'testKLineJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-29 10:39:05', '', 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_lock
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_lock`;
CREATE TABLE `xxl_job_lock` (
  `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '锁名称',
  PRIMARY KEY (`lock_name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_lock
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_log
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_log`;
CREATE TABLE `xxl_job_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `job_group` int NOT NULL COMMENT '执行器主键ID',
  `job_id` int NOT NULL COMMENT '任务，主键ID',
  `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
  `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器任务handler',
  `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器任务参数',
  `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
  `executor_fail_retry_count` int NOT NULL DEFAULT '0' COMMENT '失败重试次数',
  `trigger_time` datetime DEFAULT NULL COMMENT '调度-时间',
  `trigger_code` int NOT NULL COMMENT '调度-结果',
  `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '调度-日志',
  `handle_time` datetime DEFAULT NULL COMMENT '执行-时间',
  `handle_code` int NOT NULL COMMENT '执行-状态',
  `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '执行-日志',
  `alarm_status` tinyint NOT NULL DEFAULT '0' COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `I_trigger_time` (`trigger_time`) USING BTREE,
  KEY `I_handle_code` (`handle_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_log
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_log` VALUES (33, 1, 2, 'http://192.168.0.133:10000/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-12 17:05:18', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10000/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10000/<br>code：200<br>msg：null', '2022-08-12 17:05:19', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (34, 1, 2, 'http://192.168.0.133:10000/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-12 18:42:14', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10000/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10000/<br>code：200<br>msg：null', '2022-08-12 18:42:15', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (35, 1, 2, 'http://192.168.0.133:10000/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-12 19:19:35', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10000/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10000/<br>code：200<br>msg：null', '2022-08-12 19:19:36', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (36, 1, 2, 'http://192.168.0.133:10001/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-16 11:31:24', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10001/<br>code：200<br>msg：null', '2022-08-16 11:31:25', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (37, 1, 2, 'http://192.168.0.133:10001/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-16 11:31:32', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10001/<br>code：200<br>msg：null', '2022-08-16 11:31:33', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (38, 1, 2, 'http://192.168.0.133:10001/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-16 11:33:17', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10001/<br>code：200<br>msg：null', '2022-08-16 11:33:18', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (39, 1, 2, 'http://192.168.0.133:10001/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-16 11:42:06', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10001/<br>code：200<br>msg：null', '2022-08-16 11:42:06', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (40, 1, 2, 'http://192.168.0.133:10001/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-16 11:43:49', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10001/<br>code：200<br>msg：null', '2022-08-16 11:43:49', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (41, 1, 2, 'http://192.168.0.133:10000/', 'flushMarkPriceTask', '', NULL, 0, '2022-08-16 13:48:30', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.133<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.133:10000/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.133:10000/<br>code：200<br>msg：null', '2022-08-16 13:48:31', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (42, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 15:00:27', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (43, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 15:00:42', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (44, 3, 3, 'https://127.0.0.1:6063', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 15:02:44', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：手动录入<br>执行器-地址列表：[https://127.0.0.1:6063]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：https://127.0.0.1:6063<br>code：500<br>msg：xxl-rpc remoting error(Unrecognized SSL message, plaintext connection?), for url : https://127.0.0.1:6063/run', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (45, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 15:25:58', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 15:26:34', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (46, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 16:58:42', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 16:58:54', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (47, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 16:59:09', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 16:59:09', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (48, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 16:59:26', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 16:59:42', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (49, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:01:09', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:01:10', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (50, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:01:33', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:01:53', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (51, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:02:02', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:02:24', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (52, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:02:54', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:02:54', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (53, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:03:07', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:04:21', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (54, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:04:26', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:04:26', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (55, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:04:39', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:04:50', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (56, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:11:55', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:12:42', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (57, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:15:10', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:15:20', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (58, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:16:30', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:16:37', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (59, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:16:53', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:17:15', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (60, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:19:00', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (61, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:19:08', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (62, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:19:19', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:19:41', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (63, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:32:27', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:32:33', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.springframework.jdbc.BadSqlGrammarException: \r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n### The error may exist in com/pig4cloud/pigx/agent/mapper/RooContractTradeMapper.java (best guess)\r\n### The error may involve com.pig4cloud.pigx.agent.mapper.RooContractTradeMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE roo_contract_trade SET user_id = ? WHERE id = ?\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)\r\n	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy185.update(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy201.updateById(Unknown Source)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testB(CommissionSettlementTask.java:56)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:51)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$8ef624fb.testA(<generated>)\r\n	... 6 more\r\nCaused by: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)\r\n	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)\r\n	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)\r\n	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\r\n	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)\r\n	at com.sun.proxy.$Proxy285.update(Unknown Source)\r\n	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\r\n	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.pig4cloud.pigx.common.customize.mybatis.interceptor.MybatisInitInstanceInterceptor.intercept(MybatisInitInstanceInterceptor.java:65)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 26 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (64, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:33:28', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (65, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:33:38', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (66, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:33:44', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:33:48', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.springframework.jdbc.BadSqlGrammarException: \r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n### The error may exist in com/pig4cloud/pigx/agent/mapper/RooContractTradeMapper.java (best guess)\r\n### The error may involve com.pig4cloud.pigx.agent.mapper.RooContractTradeMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE roo_contract_trade SET user_id = ? WHERE id = ?\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)\r\n	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy185.update(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy201.updateById(Unknown Source)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testB(CommissionSettlementTask.java:56)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:51)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$d6efeeeb.testA(<generated>)\r\n	... 6 more\r\nCaused by: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)\r\n	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)\r\n	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)\r\n	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\r\n	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)\r\n	at com.sun.proxy.$Proxy285.update(Unknown Source)\r\n	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\r\n	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.pig4cloud.pigx.common.customize.mybatis.interceptor.MybatisInitInstanceInterceptor.intercept(MybatisInitInstanceInterceptor.java:65)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 26 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (67, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:35:28', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (68, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:35:38', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (69, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:35:42', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:35:52', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.springframework.jdbc.BadSqlGrammarException: \r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n### The error may exist in com/pig4cloud/pigx/agent/mapper/RooContractTradeMapper.java (best guess)\r\n### The error may involve com.pig4cloud.pigx.agent.mapper.RooContractTradeMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE roo_contract_trade SET user_id = ? WHERE id = ?\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)\r\n	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy185.update(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy201.updateById(Unknown Source)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testB(CommissionSettlementTask.java:57)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:51)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$a0190643.testA(<generated>)\r\n	... 6 more\r\nCaused by: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)\r\n	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)\r\n	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)\r\n	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\r\n	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)\r\n	at com.sun.proxy.$Proxy285.update(Unknown Source)\r\n	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\r\n	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.pig4cloud.pigx.common.customize.mybatis.interceptor.MybatisInitInstanceInterceptor.intercept(MybatisInitInstanceInterceptor.java:65)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 26 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (70, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:37:45', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:38:10', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.springframework.jdbc.BadSqlGrammarException: \r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n### The error may exist in com/pig4cloud/pigx/agent/mapper/RooContractTradeMapper.java (best guess)\r\n### The error may involve com.pig4cloud.pigx.agent.mapper.RooContractTradeMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE roo_contract_trade SET user_id = ? WHERE id = ?\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)\r\n	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy185.update(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy201.updateById(Unknown Source)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testB(CommissionSettlementTask.java:55)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:49)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$e5e8bf3.testA(<generated>)\r\n	... 6 more\r\nCaused by: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)\r\n	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)\r\n	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)\r\n	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\r\n	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)\r\n	at com.sun.proxy.$Proxy285.update(Unknown Source)\r\n	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\r\n	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.pig4cloud.pigx.common.customize.mybatis.interceptor.MybatisInitInstanceInterceptor.intercept(MybatisInitInstanceInterceptor.java:65)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 26 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (71, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:39:44', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:39:52', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.springframework.jdbc.BadSqlGrammarException: \r\n### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n### The error may exist in com/pig4cloud/pigx/agent/mapper/RooContractTradeMapper.java (best guess)\r\n### The error may involve com.pig4cloud.pigx.agent.mapper.RooContractTradeMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE roo_contract_trade SET user_id = ? WHERE id = ?\r\n### Cause: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)\r\n	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy185.update(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy201.updateById(Unknown Source)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testB(CommissionSettlementTask.java:56)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:50)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$a396eac0.testA(<generated>)\r\n	... 6 more\r\nCaused by: java.sql.SQLSyntaxErrorException: Table \'roo_broker.roo_contract_trade\' doesn\'t exist\r\n	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)\r\n	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)\r\n	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)\r\n	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)\r\n	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)\r\n	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)\r\n	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)\r\n	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)\r\n	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)\r\n	at com.sun.proxy.$Proxy285.update(Unknown Source)\r\n	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)\r\n	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.pig4cloud.pigx.common.customize.mybatis.interceptor.MybatisInitInstanceInterceptor.intercept(MybatisInitInstanceInterceptor.java:65)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy284.update(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 29 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (72, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:43:50', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:43:59', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (73, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:46:25', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (74, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:46:32', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (75, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:46:35', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (76, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:46:41', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (77, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:46:54', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:47:12', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: java.lang.Exception\r\n	at com.pig4cloud.pigx.agent.service.impl.RooContractTradeServiceImpl.testB(RooContractTradeServiceImpl.java:45)\r\n	at com.pig4cloud.pigx.agent.service.impl.RooContractTradeServiceImpl$$FastClassBySpringCGLIB$$628ec0c1.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.service.impl.RooContractTradeServiceImpl$$EnhancerBySpringCGLIB$$e31c83cd.testB(<generated>)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:53)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$8a21802b.testA(<generated>)\r\n	... 6 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (78, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:51:13', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:51:15', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (79, 3, 3, NULL, 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:52:30', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (80, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 17:52:42', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 17:52:44', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: java.lang.Exception\r\n	at com.pig4cloud.pigx.agent.service.impl.RooContractTradeServiceImpl.testB(RooContractTradeServiceImpl.java:45)\r\n	at com.pig4cloud.pigx.agent.service.impl.RooContractTradeServiceImpl$$FastClassBySpringCGLIB$$628ec0c1.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.service.impl.RooContractTradeServiceImpl$$EnhancerBySpringCGLIB$$d0e09891.testB(<generated>)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.testA(CommissionSettlementTask.java:53)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$77e594ef.testA(<generated>)\r\n	... 6 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (81, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-25 21:04:18', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-25 21:04:18', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (82, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-26 08:00:00', 200, '任务触发类型：Cron触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-26 08:00:00', 200, '佣金结算完成', 0);
INSERT INTO `xxl_job_log` VALUES (83, 3, 3, 'http://192.168.0.127:10001/', 'commissionSettlementTask', '', NULL, 0, '2022-08-27 08:00:00', 200, '任务触发类型：Cron触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-27 08:00:01', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			aqq	iuu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			iuu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n			LEFT JOIN roo_user.`user` iuu ON ruu.inviter_id = iuu.uid\n		WHERE\n			ruu.inviter_id IS NOT NULL\n		AND\n			ruu.is_broker = 0\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\n\n		UNION\n\n		SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			ruu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			ruu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n		WHERE\n			ruu.inviter_id IS NULL\n		AND\n			ruu.is_broker = 1\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\r\n### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			aqq	iuu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			iuu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n			LEFT JOIN roo_user.`user` iuu ON ruu.inviter_id = iuu.uid\n		WHERE\n			ruu.inviter_id IS NOT NULL\n		AND\n			ruu.is_broker = 0\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\n\n		UNION\n\n		SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			ruu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			ruu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n		WHERE\n			ruu.inviter_id IS NULL\n		AND\n			ruu.is_broker = 1\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy185.selectList(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy201.selectSettlementOrder(Unknown Source)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.getSettlementOrder(CommissionSettlementTask.java:82)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask.commissionSettlementTask(CommissionSettlementTask.java:90)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$FastClassBySpringCGLIB$$2d52e2cb.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.agent.job.CommissionSettlementTask$$EnhancerBySpringCGLIB$$35ec8db0.commissionSettlementTask(<generated>)\r\n	... 6 more\r\nCaused by: org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database.  Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			aqq	iuu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			iuu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n			LEFT JOIN roo_user.`user` iuu ON ruu.inviter_id = iuu.uid\n		WHERE\n			ruu.inviter_id IS NOT NULL\n		AND\n			ruu.is_broker = 0\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\n\n		UNION\n\n		SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			ruu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			ruu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n		WHERE\n			ruu.inviter_id IS NULL\n		AND\n			ruu.is_broker = 1\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\r\n### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			aqq	iuu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			iuu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n			LEFT JOIN roo_user.`user` iuu ON ruu.inviter_id = iuu.uid\n		WHERE\n			ruu.inviter_id IS NOT NULL\n		AND\n			ruu.is_broker = 0\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\n\n		UNION\n\n		SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			ruu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			ruu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n		WHERE\n			ruu.inviter_id IS NULL\n		AND\n			ruu.is_broker = 1\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\r\n	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)\r\n	at sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 27 more\r\nCaused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			aqq	iuu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			iuu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n			LEFT JOIN roo_user.`user` iuu ON ruu.inviter_id = iuu.uid\n		WHERE\n			ruu.inviter_id IS NOT NULL\n		AND\n			ruu.is_broker = 0\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\n\n		UNION\n\n		SELECT\n			rct.order_id,\n			rct.create_time,\n			rct.handling_fee,\n			ruu.chain,\n			ruu.uid,\n			ruu.inviter_id,\n			ruu.platform_commission_percentage,\n			ruu.agent_commission_percentage\n		FROM\n			roo_contract.`roo_contract_trade` rct\n			LEFT JOIN roo_user.`user` ruu ON rct.user_id = ruu.uid\n		WHERE\n			ruu.inviter_id IS NULL\n		AND\n			ruu.is_broker = 1\n		AND\n			rct.create_time >= ?\n		AND\n			rct.create_time < ?\r\n	at com.baomidou.mybatisplus.core.toolkit.ExceptionUtils.mpe(ExceptionUtils.java:39)\r\n	at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:52)\r\n	at com.baomidou.mybatisplus.extension.plugins.inner.TenantLineInnerInterceptor.beforeQuery(TenantLineInnerInterceptor.java:65)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:78)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy288.query(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)\r\n	... 33 more\r\nCaused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: \".\" \".\"\n    at line 5, column 11.\n\nWas expecting one of:\n\n    \";\"\n    \"CONNECT\"\n    \"EMIT\"\n    \"GROUP\"\n    \"HAVING\"\n    \"INTO\"\n    \"START\"\n    \"WINDOW\"\n    <EOF>\n\r\n	at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:31234)\r\n	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:31067)\r\n	at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:163)\r\n	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:188)\r\n	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)\r\n	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)\r\n	at com.baomidou.mybatisplus.extension.parser.JsqlParserSupport.parserSingle(JsqlParserSupport.java:49)\r\n	... 38 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (84, 2, 4, 'http://192.168.0.127:10002/', 'testKLineJob', '', NULL, 0, '2022-08-29 11:35:15', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10002/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10002/<br>code：200<br>msg：null', '2022-08-29 11:35:52', 500, 'java.lang.reflect.InvocationTargetException\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at com.xxl.job.core.handler.impl.MethodJobHandler.execute(MethodJobHandler.java:31)\r\n	at com.xxl.job.core.thread.JobThread.run(JobThread.java:163)\r\nCaused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database.  Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String\r\n### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String\r\n	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)\r\n	at com.sun.proxy.$Proxy205.selectList(Unknown Source)\r\n	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)\r\n	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)\r\n	at com.sun.proxy.$Proxy218.selectForCalculateKLineThread(Unknown Source)\r\n	at com.pig4cloud.pigx.contract.thread.CalculateKLineThread.testRun(CalculateKLineThread.java:142)\r\n	at com.pig4cloud.pigx.contract.thread.CalculateKLineThread$$FastClassBySpringCGLIB$$de89ea83.invoke(<generated>)\r\n	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)\r\n	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)\r\n	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)\r\n	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\r\n	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)\r\n	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)\r\n	at com.pig4cloud.pigx.contract.thread.CalculateKLineThread$$EnhancerBySpringCGLIB$$1d2b6893.testRun(<generated>)\r\n	... 6 more\r\nCaused by: org.apache.ibatis.exceptions.PersistenceException: \r\n### Error querying database.  Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String\r\n### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String\r\n	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n	at java.lang.reflect.Method.invoke(Method.java:498)\r\n	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)\r\n	... 26 more\r\nCaused by: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String\r\n	at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)\r\n	at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)\r\n	at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)\r\n	at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)\r\n	at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)\r\n	at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)\r\n	at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)\r\n	at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)\r\n	at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)\r\n	at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)\r\n	at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)\r\n	at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)\r\n	at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)\r\n	at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)\r\n	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)\r\n	at java.util.ArrayList.forEach(ArrayList.java:1257)\r\n	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)\r\n	at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)\r\n	at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)\r\n	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:69)\r\n	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)\r\n	at com.sun.proxy.$Proxy309.query(Unknown Source)\r\n	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)\r\n	... 33 more\r\n', 1);
INSERT INTO `xxl_job_log` VALUES (85, 2, 4, 'http://192.168.0.127:10002/', 'testKLineJob', '', NULL, 0, '2022-08-29 11:37:11', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10002/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10002/<br>code：200<br>msg：null', '2022-08-29 11:37:26', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (86, 2, 4, 'http://192.168.0.127:10002/', 'testKLineJob', '', NULL, 0, '2022-08-29 11:46:43', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10002/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10002/<br>code：200<br>msg：null', '2022-08-29 11:46:43', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (87, 2, 4, 'http://192.168.0.127:10002/', 'testKLineJob', '', NULL, 0, '2022-08-29 11:47:04', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10002/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10002/<br>code：200<br>msg：null', '2022-08-29 11:47:12', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (88, 2, 4, NULL, 'testKLineJob', '', NULL, 0, '2022-08-29 11:49:33', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (89, 2, 4, NULL, 'testKLineJob', '', NULL, 0, '2022-08-29 11:49:54', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (90, 2, 4, 'http://192.168.0.127:10002/', 'testKLineJob', '', NULL, 0, '2022-08-29 11:50:05', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10002/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10002/<br>code：200<br>msg：null', '2022-08-29 11:50:30', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (91, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 13:54:53', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 13:54:53', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (92, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 13:55:02', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 13:55:36', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (93, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 13:56:04', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 13:56:20', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (94, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:01:12', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:02:40', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (95, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:03:28', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:03:50', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (96, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:07:47', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:08:03', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (97, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:09:29', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:09:43', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (98, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:12:13', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:12:27', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (99, 2, 4, NULL, 'testKLineJob', '', NULL, 0, '2022-08-29 14:15:06', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (100, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:15:12', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:15:37', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (101, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:17:20', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:17:35', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (102, 2, 4, NULL, 'testKLineJob', '', NULL, 0, '2022-08-29 14:19:56', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (103, 2, 4, NULL, 'testKLineJob', '', NULL, 0, '2022-08-29 14:20:01', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (104, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:20:12', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:20:22', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (105, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:21:22', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:21:45', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (106, 2, 4, NULL, 'testKLineJob', '', NULL, 0, '2022-08-29 14:29:43', 500, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：null<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>调度失败：执行器地址为空<br><br>', NULL, 0, NULL, 1);
INSERT INTO `xxl_job_log` VALUES (107, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:29:49', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:29:58', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (108, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:33:23', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:33:29', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (109, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:35:28', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:35:41', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (110, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:42:18', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:42:30', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (111, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:43:21', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:43:24', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (112, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:43:51', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:43:52', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (113, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:44:05', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:44:05', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (114, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:44:29', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:44:29', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (115, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:44:44', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:44:44', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (116, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:45:03', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:45:03', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (117, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:46:11', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:46:11', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (118, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:46:23', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:46:23', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (119, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:46:35', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:46:35', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (120, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:47:20', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:47:21', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (121, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:47:27', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:47:28', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (122, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:47:37', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:47:37', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (123, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:48:09', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:48:25', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (124, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:48:37', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:49:24', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (125, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:51:14', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:51:14', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (126, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:51:31', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:51:31', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (127, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:52:09', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:52:09', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (128, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:52:26', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:53:33', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (129, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:56:49', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:57:13', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (130, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:57:42', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:57:42', 200, '', 0);
INSERT INTO `xxl_job_log` VALUES (131, 2, 4, 'http://192.168.0.127:10001/', 'testKLineJob', '', NULL, 0, '2022-08-29 14:57:55', 200, '任务触发类型：手动触发<br>调度机器：192.168.0.127<br>执行器-注册方式：自动注册<br>执行器-地址列表：[http://192.168.0.127:10001/]<br>路由策略：第一个<br>阻塞处理策略：单机串行<br>任务超时时间：0<br>失败重试次数：0<br><br><span style=\"color:#00c0ef;\" > >>>>>>>>>>>触发调度<<<<<<<<<<< </span><br>触发调度：<br>address：http://192.168.0.127:10001/<br>code：200<br>msg：null', '2022-08-29 14:57:55', 200, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_log_report
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_log_report`;
CREATE TABLE `xxl_job_log_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trigger_day` datetime DEFAULT NULL COMMENT '调度-时间',
  `running_count` int NOT NULL DEFAULT '0' COMMENT '运行中-日志数量',
  `suc_count` int NOT NULL DEFAULT '0' COMMENT '执行成功-日志数量',
  `fail_count` int NOT NULL DEFAULT '0' COMMENT '执行失败-日志数量',
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_log_report
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_log_report` VALUES (1, '2022-08-12 00:00:00', 0, 3, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (2, '2022-08-11 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (3, '2022-08-10 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (4, '2022-08-13 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (5, '2022-08-14 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (6, '2022-08-15 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (7, '2022-08-16 00:00:00', 0, 6, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (8, '2022-08-18 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (9, '2022-08-17 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (10, '2022-08-19 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (11, '2022-08-20 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (12, '2022-08-25 00:00:00', 0, 19, 21, NULL);
INSERT INTO `xxl_job_log_report` VALUES (13, '2022-08-24 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (14, '2022-08-23 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (15, '2022-08-26 00:00:00', 0, 1, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (16, '2022-08-27 00:00:00', 0, 0, 1, NULL);
INSERT INTO `xxl_job_log_report` VALUES (17, '2022-08-29 00:00:00', 0, 41, 7, NULL);
INSERT INTO `xxl_job_log_report` VALUES (18, '2022-08-28 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (19, '2022-08-30 00:00:00', 0, 0, 0, NULL);
INSERT INTO `xxl_job_log_report` VALUES (20, '2022-08-31 00:00:00', 0, 0, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_logglue
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_logglue`;
CREATE TABLE `xxl_job_logglue` (
  `id` int NOT NULL AUTO_INCREMENT,
  `job_id` int NOT NULL COMMENT '任务，主键ID',
  `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT 'GLUE类型',
  `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT 'GLUE源代码',
  `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE备注',
  `add_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_logglue
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_registry
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_registry`;
CREATE TABLE `xxl_job_registry` (
  `id` int NOT NULL AUTO_INCREMENT,
  `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `registry_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `registry_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `i_g_k_v` (`registry_group`,`registry_key`,`registry_value`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_registry
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_registry` VALUES (176, 'EXECUTOR', 'roo-agent-biz', 'http://192.168.0.127:10003/', '2022-08-31 20:30:05');
INSERT INTO `xxl_job_registry` VALUES (178, 'EXECUTOR', 'roo-contract-biz', 'http://192.168.0.127:10004/', '2022-08-31 20:29:59');
COMMIT;

-- ----------------------------
-- Table structure for xxl_job_user
-- ----------------------------
DROP TABLE IF EXISTS `xxl_job_user`;
CREATE TABLE `xxl_job_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
  `role` tinyint NOT NULL COMMENT '角色：0-普通用户、1-管理员',
  `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `i_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of xxl_job_user
-- ----------------------------
BEGIN;
INSERT INTO `xxl_job_user` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
